-
Re: Daily Update Solution without the need to open the sheet, use Zapier, or similar
Just a note on the date-based helper columns that are updated via automation to refresh calculated cells - they can only ever work once a day, regardless of how many times you try to trigger them. Th…1 · -
Re: Summary Fields in Automation
You wouldn't create a column named {{Project Manager}}. The double braces denote a reference in the automation context. So your automation would reference the [Project Manager] cell on each affected …1 · -
Re: countifs and a date that falls between two dates
The first formula is missing a comma before "<=TODAY())"1 ·